Problem Note 68360: The METALIB procedure returns the error "the URL= LIBNAME option must be included on the LIBNAME statement when connecting to Hive"
 |  |  |  |  |
The METALIB procedure might fail to register tables in a HADOOP library or fail to update metadata for tables that have already been registered. The following error is returned by the Register Tables wizard and PROC METALIB:
This problem occurs when all of the following are true:
- The HADOOP library connects to Cloudera with APACHE KNOX.
- The library definition in the metadata sets the Hive JDBC URL property within the library properties ► Options ► Advanced Options ► Connection.
The problem affects only PROC METALIB. The HADOOP LIBNAME statement assigns correctly and can be used successfully in SAS programs and clients.
Circumvention
As a circumvention, you can register tables using the following steps. These steps work only for the initial table registration and have no effect on updating metadata for a table that has already been registered. This circumvention is valid only for SAS® Management Console 9.4_M7, SAS® Data Integration Studio 4.904 if Hot Fix D8Y008 is applied, and for SAS® Data Integration Studio 4.905.
- On the machine that runs SAS Management Console or SAS Data Integration Studio, locate the sasmc.ini or distudio.ini file. Here are the typical directory locations for these files:
Windows: C:\Program Files\SAS\SASManagementConsole\9.4\sasmc.ini or C:\Program Files\SASHome\SASDataIntegrationStudio\4.7\distudio.ini
UNIX: /opt/SAS/SASHome/SASManagementConsole/9.4/sasmc.ini - Make a copy of the INI file as a backup. Do not change this backup copy.
- Open the original INI file for editing and add the IGNOREMETALIB option to the end of the MainClass line, as follows:
MainClass=com.sas.console.visuals.MainConsole -ignoremetalib
Note that there might be other options in the same line in your file. Do not make changes to those options.
- Save and close the INI file.
- Open a new session of SAS Management Console or SAS Data Integration Studio to register the tables.
This circumvention causes SAS Management Console and SAS Data Integration Studio to use Dictionary Tables and SQL pass-through to collect table data, rather than PROC METALIB.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | Base SAS | Microsoft Windows 8 Pro x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 |
| Microsoft Windows 8 Pro 32-bit | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 8 Enterprise 32-bit | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft® Windows® for x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| z/OS | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| z/OS 64-bit | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 10 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2008 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2008 R2 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2008 for x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 Datacenter | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 Std | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2016 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2019 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Enterprise 32 bit | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Enterprise x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Home Premium 32 bit | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Home Premium x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Professional 32 bit | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Professional x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Ultimate 32 bit | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Ultimate x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| 64-bit Enabled AIX | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| 64-bit Enabled Solaris | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| HP-UX IPF | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Linux for x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Solaris for x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||